Files Received

Description

This File Rule (also referred to as AsFile) allows configuration to translate incoming data and insert it directly into the database.  AsFile can also be configured to selectively insert records into the database based upon the data in the inbound SOAP message.

 

The configuration for each File has two sections: XMLData and XSLT.  The XMLData section assigns values to attributes prior to the transformation process.  The XSLT defines how the information will be transformed.  

 

The XMLData section can be configured using the elements and attributes described below.  The XSLT section transforms data according to a stylesheet.  Each Attribute defined in the XMLData section that will be needed in the XSLT stylesheet must first be declared as a parameter in the XSLT.

 

Refer to the Rules Palette help system section Admin Explorer | Files Received for additional information on configuring File and the XSLT section.

 

Note:  Parameter, Attribute and Variable are interchangeable terms depending on which section you are working with.  An attribute in the XMLData section is called a parameter in the XSLT section.

 

Files Received Elements/Attributes Table

Element/Tag

Definition

 Attribute

Element/Attribute Value and Description

 

<File>

The opening and closing tag.

 

 

   <AssignAttributes>

Required element

 

 

     <Attribute>

Required element

NAME

 

 

 

TYPE

Required;

Name of attribute

 

 

VALUE

XPATH

GUID

SQL

     <PreInsert>

Optional element;

PreInsert allows for functionally to be exercised prior to records being inserted into the database.  Only used when there is a need to call other functionality in the application.

 

 

          <Object>

Used to define the name of the Java class being called.

 

 

                <Parameters>

Allows for passing parameters to the class.

 

 

    <PostInsert>

 

Optional element;

PostInsert allows for functionally after the records are being inserted into the database.  Only used when there is a need to call other functionality in the application.

 

 

            <Object>

Used to define the name of the Java class being called.

 

 

                 <Parameters>

Allows for passing parameters to the class.

 

 

 

 

XML Example

<File>

     <AssignAttributes>

            <Attribute NAME="ImportMapName" TYPE="VALUE">AsXml</Attribute>

             <Attribute NAME="ClassName" TYPE="VALUE">com.adminserver.utl.JibxListUtl</Attribute>

     </AssignAttributes>

     <PostInsert>

            <Object CLASS="com.adminserver.pas.webservice.bll.AsFilePostInsertIndividualActivityProcessorBll">

                  <Parameters>

                         <Parameter NAME="ActivityClientNumber">ActivityClientNumber</Parameter>

                  </Parameters>

           </Object>

      </PostInsert>

</File>